http://www.dnnfoodbank.com RSS feeds for DNN Modules for Non-Profit Food Banks 60 http://www.dnnfoodbank.com/More-/Support/ID/12/Reporting-by-Age-Group#Comments 0 http://www.dnnfoodbank.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=89&ModuleID=415&ArticleID=12 http://www.dnnfoodbank.com/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=12&PortalID=0&TabID=89 http://www.dnnfoodbank.com/More-/Support/ID/12/Reporting-by-Age-Group Stored procedure added to report on a client family age demographics. CREATE PROCEDURE [dbo].[GIBS_FBClients_AgeGroupReport] @ClientID int AS BEGIN SET NOCOUNT ON; CREATE TABLE #Temp ( DOB Date NULL ); INSERT INTO #Temp (DOB) SELECT GIBS_FBClientsAFM.ClAddFamMemDOB AS DOB FROM GIBS_FBClients INNER JOIN GIBS_FBClientsAddFamMem AS GIBS_FBClientsAFM ON GIBS_FBClients.ClientID = GIBS_FBClientsAFM.ClientID WHERE GIBS_FBClients.ClientID = @ClientID UNION ALL SELECT GIBS_FBClients.ClientDOB AS DOB FROM GIBS_FBClients WHERE GIBS_FBClients.ClientID = @ClientID -- SELECT THE REPORT FROM TEMP TABLE SELECT count( dbo.fn_GIBS_FBClients_GetAgeGroup(DOB,GetDate())) As AgeGroupCount , dbo.fn_GIBS_FBClients_GetAgeGroup(DOB,GetDate()) As AgeGroup FROM #Temp GROUP BY dbo.fn_GIBS_FBClients_GetAgeGroup(DOB,GetDate()) DROP TABLE #Temp END Joseph Aucoin Thu, 05 Sep 2013 11:57:00 GMT f1397696-738c-4295-afcd-943feb885714:12